Data type considerations and exceptions
When replicating from Google Cloud SQL for PostgreSQL database to a PostgreSQL-based target, source and target data types will be identical, with the following exceptions:
Google Cloud SQL for PostgreSQL source | PostgreSQL-based target |
---|---|
ENUM |
STRING |
COMPOSITE |
STRING |
NUMERIC |
NUMERIC (28,6) |
NUMERIC (p,s) A numeric array with precision and scale. |
NUMERIC A numeric array without precision and scale. |
TINTERVAL |
Information note
As PostgreSQL have discontinued support for the TINTERVAL data type, tables with this data type will not be created on the target if the target database version does not support it. |
See also the note about JSON data type replication in Google Cloud SQL for PostgreSQL source data types.